Code
import pandas as pd
test = pd.read_csv("listings 2.csv")
test.head(5)| id | listing_url | scrape_id | last_scraped | source | name | description | neighborhood_overview | picture_url | host_id | ... | review_scores_communication | review_scores_location | review_scores_value | license | instant_bookable | calculated_host_listings_count | calculated_host_listings_count_entire_homes | calculated_host_listings_count_private_rooms | calculated_host_listings_count_shared_rooms | reviews_per_month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 3686 | https://www.airbnb.com/rooms/3686 | 20231218032619 | 2023-12-18 | city scrape | Home in Washington · ★4.64 · 1 bedroom · 1 bed... | NaN | We love that our neighborhood is up and coming... | https://a0.muscache.com/pictures/61e02c7e-3d66... | 4645 | ... | 4.84 | 3.91 | 4.64 | NaN | f | 1 | 0 | 1 | 0 | 0.53 |
| 1 | 3943 | https://www.airbnb.com/rooms/3943 | 20231218032619 | 2023-12-18 | city scrape | Townhouse in Washington · ★4.83 · 1 bedroom · ... | NaN | This rowhouse is centrally located in the hear... | https://a0.muscache.com/pictures/airflow/Hosti... | 5059 | ... | 4.91 | 4.57 | 4.75 | Hosted License: 5007242201001033 | f | 5 | 0 | 5 | 0 | 2.78 |
| 2 | 4197 | https://www.airbnb.com/rooms/4197 | 20231218032619 | 2023-12-18 | city scrape | Home in Washington · ★4.85 · 1 bedroom · 1 bed... | NaN | Our area, the Eastern Market neighborhood of C... | https://a0.muscache.com/pictures/miso/Hosting-... | 5061 | ... | 4.98 | 4.96 | 4.95 | Hosted License: 5007242201000749 | f | 2 | 0 | 2 | 0 | 0.33 |
| 3 | 4529 | https://www.airbnb.com/rooms/4529 | 20231218032619 | 2023-12-18 | city scrape | Home in Washington · ★4.66 · 1 bedroom · 1 bed... | NaN | Very quiet neighborhood and it is easy accessi... | https://a0.muscache.com/pictures/86072003/6709... | 5803 | ... | 4.93 | 4.51 | 4.83 | Exempt | f | 2 | 0 | 2 | 0 | 0.58 |
| 4 | 4967 | https://www.airbnb.com/rooms/4967 | 20231218032619 | 2023-12-18 | previous scrape | Home in Washington · ★4.74 · 1 bedroom · 1 bed... | NaN | NaN | https://a0.muscache.com/pictures/2439810/bb320... | 7086 | ... | 4.93 | 4.21 | 4.64 | NaN | f | 3 | 0 | 3 | 0 | 0.19 |
5 rows × 75 columns

